/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package sv.com.intesal.compra.sql;

/**
 *
 * @author JM
 */
public class SQLCategoria {

    public static final String INSERTAR = "INSERT INTO categoria(nombre_cat) VALUES (?)";
    public static final String MODIFICAR = "UPDATE categoria SET nombre_cat=? WHERE id_cat=?";
    public static final String ELIMINAR = "DELETE FROM categoria WHERE id_cat=?";
    public static final String ALL = "SELECT id_cat, nombre_cat FROM categoria order by nombre_cat";
    public static final String ForCombo = "SELECT c.id_cat, c.nombre_cat, sc.id_su, sc.nombre_su FROM categoria c, sub_categoria sc WHERE c.id_cat = sc.id_cat";

}
